Dataset statistics
| Number of variables | 48 |
|---|---|
| Number of observations | 1048575 |
| Missing cells | 46103314 |
| Missing cells (%) | 91.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 384.0 MiB |
| Average record size in memory | 384.0 B |
Variable types
| Numeric | 1 |
|---|---|
| Categorical | 8 |
| Text | 10 |
| Unsupported | 29 |
Carrier has constant value "Aircel" | Constant |
Unnamed: 24 has constant value "0.9" | Constant |
Unnamed: 25 has constant value "0.0" | Constant |
Unnamed: 27 has constant value "user" | Constant |
Unnamed: 28 has constant value "0.9" | Constant |
Unnamed: 29 has constant value "0.0" | Constant |
Unnamed: 37 has constant value "Andhra Pradesh in" | Constant |
Unnamed: 45 has constant value "user" | Constant |
Unnamed: 46 has constant value "0.9" | Constant |
Unnamed: 47 has constant value "0.0" | Constant |
Number is highly overall correlated with Unnamed: 22 | High correlation |
Unnamed: 22 is highly overall correlated with Number | High correlation |
Name has 46189 (4.4%) missing values | Missing |
Gender has 992757 (94.7%) missing values | Missing |
Address has 373038 (35.6%) missing values | Missing |
JobTitle has 1022494 (97.5%) missing values | Missing |
CompanyName has 1026899 (97.9%) missing values | Missing |
Email has 735434 (70.1%) missing values | Missing |
Facebook has 1023830 (97.6%) missing values | Missing |
Twitter has 1036915 (98.9%) missing values | Missing |
Unnamed: 10 has 1048575 (100.0%) missing values | Missing |
Unnamed: 11 has 1048575 (100.0%) missing values | Missing |
Unnamed: 12 has 1048575 (100.0%) missing values | Missing |
Unnamed: 13 has 1048575 (100.0%) missing values | Missing |
Unnamed: 14 has 1048575 (100.0%) missing values | Missing |
Unnamed: 15 has 1048575 (100.0%) missing values | Missing |
Unnamed: 16 has 1048529 (> 99.9%) missing values | Missing |
Unnamed: 17 has 1048560 (> 99.9%) missing values | Missing |
Unnamed: 18 has 1048569 (> 99.9%) missing values | Missing |
Unnamed: 19 has 1048572 (> 99.9%) missing values | Missing |
Unnamed: 20 has 1048572 (> 99.9%) missing values | Missing |
Unnamed: 21 has 1048572 (> 99.9%) missing values | Missing |
Unnamed: 22 has 1048571 (> 99.9%) missing values | Missing |
Unnamed: 23 has 1048572 (> 99.9%) missing values | Missing |
Unnamed: 24 has 1048574 (> 99.9%) missing values | Missing |
Unnamed: 25 has 1048574 (> 99.9%) missing values | Missing |
Unnamed: 26 has 1048575 (100.0%) missing values | Missing |
Unnamed: 27 has 1048574 (> 99.9%) missing values | Missing |
Unnamed: 28 has 1048574 (> 99.9%) missing values | Missing |
Unnamed: 29 has 1048574 (> 99.9%) missing values | Missing |
Unnamed: 30 has 1048575 (100.0%) missing values | Missing |
Unnamed: 31 has 1048575 (100.0%) missing values | Missing |
Unnamed: 32 has 1048575 (100.0%) missing values | Missing |
Unnamed: 33 has 1048575 (100.0%) missing values | Missing |
Unnamed: 34 has 1048575 (100.0%) missing values | Missing |
Unnamed: 35 has 1048575 (100.0%) missing values | Missing |
Unnamed: 36 has 1048575 (100.0%) missing values | Missing |
Unnamed: 37 has 1048574 (> 99.9%) missing values | Missing |
Unnamed: 38 has 1048575 (100.0%) missing values | Missing |
Unnamed: 39 has 1048575 (100.0%) missing values | Missing |
Unnamed: 40 has 1048575 (100.0%) missing values | Missing |
Unnamed: 41 has 1048575 (100.0%) missing values | Missing |
Unnamed: 42 has 1048575 (100.0%) missing values | Missing |
Unnamed: 43 has 1048575 (100.0%) missing values | Missing |
Unnamed: 44 has 1048575 (100.0%) missing values | Missing |
Unnamed: 45 has 1048574 (> 99.9%) missing values | Missing |
Unnamed: 46 has 1048574 (> 99.9%) missing values | Missing |
Unnamed: 47 has 1048574 (> 99.9%) missing values | Missing |
Number has unique values | Unique |
Facebook is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Twitter is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 23 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 26 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 30 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 31 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 32 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 33 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 34 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 35 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 36 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 38 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 39 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 40 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 41 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 42 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 43 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 44 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2024-07-17 18:14:06.441835 |
|---|---|
| Analysis finished | 2024-07-17 18:15:22.278793 |
| Duration | 1 minute and 15.84 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
Number
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 1048575 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.1878237 × 1011 |
| Minimum | 9.17035 × 1011 |
|---|---|
| Maximum | 9.1986 × 1011 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 MiB |
Quantile statistics
| Minimum | 9.17035 × 1011 |
|---|---|
| 5-th percentile | 9.1709755 × 1011 |
| Q1 | 9.1779304 × 1011 |
| median | 9.1880144 × 1011 |
| Q3 | 9.1970047 × 1011 |
| 95-th percentile | 9.1985923 × 1011 |
| Maximum | 9.1986 × 1011 |
| Range | 2.825 × 109 |
| Interquartile range (IQR) | 1.9074319 × 109 |
Descriptive statistics
| Standard deviation | 1.0090748 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.001098274 |
| Kurtosis | -1.2329713 |
| Mean | 9.1878237 × 1011 |
| Median Absolute Deviation (MAD) | 8.9908812 × 108 |
| Skewness | -0.52259525 |
| Sum | 9.6341222 × 1017 |
| Variance | 1.0182319 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.17097 × 1011 | 1 | < 0.1% |
| 9.196138191 × 1011 | 1 | < 0.1% |
| 9.196138195 × 1011 | 1 | < 0.1% |
| 9.196138194 × 1011 | 1 | < 0.1% |
| 9.196138194 × 1011 | 1 | < 0.1% |
| 9.196138194 × 1011 | 1 | < 0.1% |
| 9.196138194 × 1011 | 1 | < 0.1% |
| 9.196138194 × 1011 | 1 | < 0.1% |
| 9.196138193 × 1011 | 1 | < 0.1% |
| 9.196138193 × 1011 | 1 | < 0.1% |
| Other values (1048565) | 1048565 |
| Value | Count | Frequency (%) |
| 9.17035 × 1011 | 1 | |
| 9.17035 × 1011 | 1 | |
| 9.17035 × 1011 | 1 | |
| 9.170350001 × 1011 | 1 | |
| 9.170350001 × 1011 | 1 | |
| 9.170350001 × 1011 | 1 | |
| 9.170350008 × 1011 | 1 | |
| 9.170350014 × 1011 | 1 | |
| 9.170350015 × 1011 | 1 | |
| 9.170350017 × 1011 | 1 |
| Value | Count | Frequency (%) |
| 9.1986 × 1011 | 1 | |
| 9.1986 × 1011 | 1 | |
| 9.1986 × 1011 | 1 | |
| 9.1986 × 1011 | 1 | |
| 9.198599999 × 1011 | 1 | |
| 9.198599999 × 1011 | 1 | |
| 9.198599999 × 1011 | 1 | |
| 9.198599999 × 1011 | 1 | |
| 9.198599999 × 1011 | 1 | |
| 9.198599999 × 1011 | 1 |
Carrier
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.0 MiB |
| Aircel |
|---|
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 6291450 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Aircel |
|---|---|
| 2nd row | Aircel |
| 3rd row | Aircel |
| 4th row | Aircel |
| 5th row | Aircel |
Common Values
| Value | Count | Frequency (%) |
| Aircel | 1048575 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| aircel | 1048575 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1048575 | |
| i | 1048575 | |
| r | 1048575 | |
| c | 1048575 | |
| e | 1048575 | |
| l | 1048575 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6291450 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 1048575 | |
| i | 1048575 | |
| r | 1048575 | |
| c | 1048575 | |
| e | 1048575 | |
| l | 1048575 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6291450 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 1048575 | |
| i | 1048575 | |
| r | 1048575 | |
| c | 1048575 | |
| e | 1048575 | |
| l | 1048575 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6291450 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 1048575 | |
| i | 1048575 | |
| r | 1048575 | |
| c | 1048575 | |
| e | 1048575 | |
| l | 1048575 |
Name
Text
MISSING 
| Distinct | 626446 |
|---|---|
| Distinct (%) | 62.5% |
| Missing | 46189 |
| Missing (%) | 4.4% |
| Memory size | 8.0 MiB |
Length
| Max length | 1462 |
|---|---|
| Median length | 107 |
| Mean length | 11.264574 |
| Min length | 1 |
Characters and Unicode
| Total characters | 11291451 |
|---|---|
| Distinct characters | 1064 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 558218 ? |
|---|---|
| Unique (%) | 55.7% |
Sample
| 1st row | Puneet Ji |
|---|---|
| 2nd row | Javed Cdm Mt |
| 3rd row | Sharada |
| 4th row | Ankit Singh |
| 5th row | Lokesh M |
| Value | Count | Frequency (%) |
| kumar | 40085 | 2.0% |
| khan | 17431 | 0.9% |
| das | 12961 | 0.7% |
| da | 12476 | 0.6% |
| ali | 12078 | 0.6% |
| mohd | 11772 | 0.6% |
| singh | 11251 | 0.6% |
| reddy | 10883 | 0.6% |
| 10065 | 0.5% | |
| k | 9980 | 0.5% |
| Other values (215425) | 1821561 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1717920 | 15.2% |
| 968527 | 8.6% | |
| i | 749360 | 6.6% |
| n | 587671 | 5.2% |
| h | 584400 | 5.2% |
| r | 574455 | 5.1% |
| e | 467215 | 4.1% |
| u | 461760 | 4.1% |
| m | 346858 | 3.1% |
| d | 319209 | 2.8% |
| Other values (1054) | 4514076 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11291451 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1717920 | 15.2% |
| 968527 | 8.6% | |
| i | 749360 | 6.6% |
| n | 587671 | 5.2% |
| h | 584400 | 5.2% |
| r | 574455 | 5.1% |
| e | 467215 | 4.1% |
| u | 461760 | 4.1% |
| m | 346858 | 3.1% |
| d | 319209 | 2.8% |
| Other values (1054) | 4514076 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11291451 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1717920 | 15.2% |
| 968527 | 8.6% | |
| i | 749360 | 6.6% |
| n | 587671 | 5.2% |
| h | 584400 | 5.2% |
| r | 574455 | 5.1% |
| e | 467215 | 4.1% |
| u | 461760 | 4.1% |
| m | 346858 | 3.1% |
| d | 319209 | 2.8% |
| Other values (1054) | 4514076 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11291451 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1717920 | 15.2% |
| 968527 | 8.6% | |
| i | 749360 | 6.6% |
| n | 587671 | 5.2% |
| h | 584400 | 5.2% |
| r | 574455 | 5.1% |
| e | 467215 | 4.1% |
| u | 461760 | 4.1% |
| m | 346858 | 3.1% |
| d | 319209 | 2.8% |
| Other values (1054) | 4514076 |
Gender
Text
MISSING 
| Distinct | 534 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 992757 |
| Missing (%) | 94.7% |
| Memory size | 8.0 MiB |
Length
| Max length | 53 |
|---|---|
| Median length | 4 |
| Mean length | 4.2165431 |
| Min length | 1 |
Characters and Unicode
| Total characters | 235359 |
|---|---|
| Distinct characters | 146 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 490 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | MALE |
|---|---|
| 2nd row | MALE |
| 3rd row | MALE |
| 4th row | MALE |
| 5th row | MALE |
| Value | Count | Frequency (%) |
| male | 49966 | |
| female | 5161 | 9.2% |
| 2 | 30 | 0.1% |
| 29 | 0.1% | |
| s | 28 | < 0.1% |
| v | 20 | < 0.1% |
| 0 | 17 | < 0.1% |
| i | 15 | < 0.1% |
| b | 10 | < 0.1% |
| k | 10 | < 0.1% |
| Other values (593) | 759 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 60292 | |
| M | 55180 | |
| A | 55171 | |
| L | 55141 | |
| F | 5167 | 2.2% |
| 596 | 0.3% | |
| a | 540 | 0.2% |
| i | 222 | 0.1% |
| r | 212 | 0.1% |
| e | 198 | 0.1% |
| Other values (136) | 2640 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 235359 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 60292 | |
| M | 55180 | |
| A | 55171 | |
| L | 55141 | |
| F | 5167 | 2.2% |
| 596 | 0.3% | |
| a | 540 | 0.2% |
| i | 222 | 0.1% |
| r | 212 | 0.1% |
| e | 198 | 0.1% |
| Other values (136) | 2640 | 1.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 235359 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 60292 | |
| M | 55180 | |
| A | 55171 | |
| L | 55141 | |
| F | 5167 | 2.2% |
| 596 | 0.3% | |
| a | 540 | 0.2% |
| i | 222 | 0.1% |
| r | 212 | 0.1% |
| e | 198 | 0.1% |
| Other values (136) | 2640 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 235359 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 60292 | |
| M | 55180 | |
| A | 55171 | |
| L | 55141 | |
| F | 5167 | 2.2% |
| 596 | 0.3% | |
| a | 540 | 0.2% |
| i | 222 | 0.1% |
| r | 212 | 0.1% |
| e | 198 | 0.1% |
| Other values (136) | 2640 | 1.1% |
Address
Text
MISSING 
| Distinct | 7263 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 373038 |
| Missing (%) | 35.6% |
| Memory size | 8.0 MiB |
Length
| Max length | 125 |
|---|---|
| Median length | 111 |
| Mean length | 13.801275 |
| Min length | 1 |
Characters and Unicode
| Total characters | 9323272 |
|---|---|
| Distinct characters | 203 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6340 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | Andhra Pradesh in |
|---|---|
| 2nd row | Andhra Pradesh |
| 3rd row | Andhra Pradesh |
| 4th row | Andhra Pradesh |
| 5th row | Andhra Pradesh in |
| Value | Count | Frequency (%) |
| pradesh | 463714 | |
| andhra | 463474 | |
| in | 384885 | |
| bihar | 162525 | 10.5% |
| hyderabad | 14577 | 0.9% |
| rajasthan | 12852 | 0.8% |
| assam | 10679 | 0.7% |
| 2117 | 0.1% | |
| jammu | 2043 | 0.1% |
| kashmir | 2014 | 0.1% |
| Other values (6822) | 33624 | 2.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1216480 | |
| 1152165 | ||
| r | 1121475 | |
| h | 1113927 | |
| d | 965730 | |
| n | 876688 | |
| i | 562558 | |
| s | 503354 | |
| e | 486876 | |
| A | 476377 | 5.1% |
| Other values (193) | 847642 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9323272 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1216480 | |
| 1152165 | ||
| r | 1121475 | |
| h | 1113927 | |
| d | 965730 | |
| n | 876688 | |
| i | 562558 | |
| s | 503354 | |
| e | 486876 | |
| A | 476377 | 5.1% |
| Other values (193) | 847642 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9323272 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1216480 | |
| 1152165 | ||
| r | 1121475 | |
| h | 1113927 | |
| d | 965730 | |
| n | 876688 | |
| i | 562558 | |
| s | 503354 | |
| e | 486876 | |
| A | 476377 | 5.1% |
| Other values (193) | 847642 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9323272 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1216480 | |
| 1152165 | ||
| r | 1121475 | |
| h | 1113927 | |
| d | 965730 | |
| n | 876688 | |
| i | 562558 | |
| s | 503354 | |
| e | 486876 | |
| A | 476377 | 5.1% |
| Other values (193) | 847642 |
JobTitle
Text
MISSING 
| Distinct | 7061 |
|---|---|
| Distinct (%) | 27.1% |
| Missing | 1022494 |
| Missing (%) | 97.5% |
| Memory size | 8.0 MiB |
Length
| Max length | 2286 |
|---|---|
| Median length | 100 |
| Mean length | 9.9498485 |
| Min length | 1 |
Characters and Unicode
| Total characters | 259502 |
|---|---|
| Distinct characters | 322 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5906 ? |
|---|---|
| Unique (%) | 22.6% |
Sample
| 1st row | 500062 |
|---|---|
| 2nd row | 500027 |
| 3rd row | in |
| 4th row | Mumbai |
| 5th row | in |
| Value | Count | Frequency (%) |
| in | 7581 | |
| hyderabad | 4072 | 10.1% |
| pradesh | 3590 | 8.9% |
| andhra | 3573 | 8.9% |
| india | 2495 | 6.2% |
| warangal | 414 | 1.0% |
| vijayawada | 321 | 0.8% |
| engineer | 204 | 0.5% |
| tirupathi | 204 | 0.5% |
| karimnagar | 183 | 0.5% |
| Other values (6020) | 17628 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 31149 | 12.0% |
| 30172 | 11.6% | |
| d | 20528 | 7.9% |
| n | 19664 | 7.6% |
| r | 18336 | 7.1% |
| i | 16657 | 6.4% |
| e | 14384 | 5.5% |
| h | 9931 | 3.8% |
| 0 | 8036 | 3.1% |
| s | 7316 | 2.8% |
| Other values (312) | 83329 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 259502 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 31149 | 12.0% |
| 30172 | 11.6% | |
| d | 20528 | 7.9% |
| n | 19664 | 7.6% |
| r | 18336 | 7.1% |
| i | 16657 | 6.4% |
| e | 14384 | 5.5% |
| h | 9931 | 3.8% |
| 0 | 8036 | 3.1% |
| s | 7316 | 2.8% |
| Other values (312) | 83329 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 259502 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 31149 | 12.0% |
| 30172 | 11.6% | |
| d | 20528 | 7.9% |
| n | 19664 | 7.6% |
| r | 18336 | 7.1% |
| i | 16657 | 6.4% |
| e | 14384 | 5.5% |
| h | 9931 | 3.8% |
| 0 | 8036 | 3.1% |
| s | 7316 | 2.8% |
| Other values (312) | 83329 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 259502 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 31149 | 12.0% |
| 30172 | 11.6% | |
| d | 20528 | 7.9% |
| n | 19664 | 7.6% |
| r | 18336 | 7.1% |
| i | 16657 | 6.4% |
| e | 14384 | 5.5% |
| h | 9931 | 3.8% |
| 0 | 8036 | 3.1% |
| s | 7316 | 2.8% |
| Other values (312) | 83329 |
CompanyName
Text
MISSING 
| Distinct | 8923 |
|---|---|
| Distinct (%) | 41.2% |
| Missing | 1026899 |
| Missing (%) | 97.9% |
| Memory size | 8.0 MiB |
Length
| Max length | 2729 |
|---|---|
| Median length | 67 |
| Mean length | 10.37327 |
| Min length | 1 |
Characters and Unicode
| Total characters | 224851 |
|---|---|
| Distinct characters | 293 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 7929 ? |
|---|---|
| Unique (%) | 36.6% |
Sample
| 1st row | Hyderabad |
|---|---|
| 2nd row | Hyderbad |
| 3rd row | in |
| 4th row | Hyderabad |
| 5th row | Galaxy Stone Man |
| Value | Count | Frequency (%) |
| india | 2902 | 8.5% |
| pradesh | 2688 | 7.9% |
| andhra | 2685 | 7.9% |
| in | 1786 | 5.2% |
| hyderabad | 1573 | 4.6% |
| ltd | 307 | 0.9% |
| 252 | 0.7% | |
| bank | 214 | 0.6% |
| student | 198 | 0.6% |
| pvt | 180 | 0.5% |
| Other values (7814) | 21261 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 24476 | 10.9% |
| 23323 | 10.4% | |
| d | 15056 | 6.7% |
| n | 15024 | 6.7% |
| r | 14499 | 6.4% |
| e | 13251 | 5.9% |
| i | 12779 | 5.7% |
| h | 8316 | 3.7% |
| s | 7930 | 3.5% |
| t | 6703 | 3.0% |
| Other values (283) | 83494 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 224851 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 24476 | 10.9% |
| 23323 | 10.4% | |
| d | 15056 | 6.7% |
| n | 15024 | 6.7% |
| r | 14499 | 6.4% |
| e | 13251 | 5.9% |
| i | 12779 | 5.7% |
| h | 8316 | 3.7% |
| s | 7930 | 3.5% |
| t | 6703 | 3.0% |
| Other values (283) | 83494 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 224851 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 24476 | 10.9% |
| 23323 | 10.4% | |
| d | 15056 | 6.7% |
| n | 15024 | 6.7% |
| r | 14499 | 6.4% |
| e | 13251 | 5.9% |
| i | 12779 | 5.7% |
| h | 8316 | 3.7% |
| s | 7930 | 3.5% |
| t | 6703 | 3.0% |
| Other values (283) | 83494 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 224851 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 24476 | 10.9% |
| 23323 | 10.4% | |
| d | 15056 | 6.7% |
| n | 15024 | 6.7% |
| r | 14499 | 6.4% |
| e | 13251 | 5.9% |
| i | 12779 | 5.7% |
| h | 8316 | 3.7% |
| s | 7930 | 3.5% |
| t | 6703 | 3.0% |
| Other values (283) | 83494 |
Email
Text
MISSING 
| Distinct | 301897 |
|---|---|
| Distinct (%) | 96.4% |
| Missing | 735434 |
| Missing (%) | 70.1% |
| Memory size | 8.0 MiB |
Length
| Max length | 63 |
|---|---|
| Median length | 46 |
| Mean length | 22.722713 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7115413 |
|---|---|
| Distinct characters | 130 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 300104 ? |
|---|---|
| Unique (%) | 95.8% |
Sample
| 1st row | mobilearena@mail.com |
|---|---|
| 2nd row | arunshonu45@gmail.com |
| 3rd row | mdabdur229@gmail.com |
| 4th row | in |
| 5th row | sunilhait28@gmail.com |
| Value | Count | Frequency (%) |
| in | 8520 | 2.7% |
| pradesh | 322 | 0.1% |
| andhra | 321 | 0.1% |
| hyderabad | 173 | 0.1% |
| india | 71 | < 0.1% |
| 47 | < 0.1% | |
| ltd | 42 | < 0.1% |
| abc@gmail.com | 37 | < 0.1% |
| rajasthan | 33 | < 0.1% |
| pvt | 30 | < 0.1% |
| Other values (302107) | 305144 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 916108 | 12.9% |
| m | 759218 | 10.7% |
| i | 546091 | 7.7% |
| o | 415273 | 5.8% |
| l | 394237 | 5.5% |
| . | 357680 | 5.0% |
| g | 338982 | 4.8% |
| c | 333358 | 4.7% |
| @ | 302385 | 4.2% |
| r | 242651 | 3.4% |
| Other values (120) | 2509430 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7115413 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 916108 | 12.9% |
| m | 759218 | 10.7% |
| i | 546091 | 7.7% |
| o | 415273 | 5.8% |
| l | 394237 | 5.5% |
| . | 357680 | 5.0% |
| g | 338982 | 4.8% |
| c | 333358 | 4.7% |
| @ | 302385 | 4.2% |
| r | 242651 | 3.4% |
| Other values (120) | 2509430 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7115413 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 916108 | 12.9% |
| m | 759218 | 10.7% |
| i | 546091 | 7.7% |
| o | 415273 | 5.8% |
| l | 394237 | 5.5% |
| . | 357680 | 5.0% |
| g | 338982 | 4.8% |
| c | 333358 | 4.7% |
| @ | 302385 | 4.2% |
| r | 242651 | 3.4% |
| Other values (120) | 2509430 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7115413 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 916108 | 12.9% |
| m | 759218 | 10.7% |
| i | 546091 | 7.7% |
| o | 415273 | 5.8% |
| l | 394237 | 5.5% |
| . | 357680 | 5.0% |
| g | 338982 | 4.8% |
| c | 333358 | 4.7% |
| @ | 302385 | 4.2% |
| r | 242651 | 3.4% |
| Other values (120) | 2509430 |
Facebook
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1023830 |
|---|---|
| Missing (%) | 97.6% |
| Memory size | 8.0 MiB |
Twitter
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1036915 |
|---|---|
| Missing (%) | 98.9% |
| Memory size | 8.0 MiB |
Unnamed: 10
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 11
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 12
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 13
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 14
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 15
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 16
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048529 |
|---|---|
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
Unnamed: 17
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048560 |
|---|---|
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
Unnamed: 18
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048569 |
|---|---|
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
Unnamed: 19
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048572 |
|---|---|
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
Unnamed: 20
Text
MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 66.7% |
| Missing | 1048572 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3 |
| Min length | 1 |
Characters and Unicode
| Total characters | 9 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 33.3% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | user |
| 3rd row | user |
| Value | Count | Frequency (%) |
| user | 2 | |
| 0 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 2 | |
| s | 2 | |
| e | 2 | |
| r | 2 | |
| 0 | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| u | 2 | |
| s | 2 | |
| e | 2 | |
| r | 2 | |
| 0 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| u | 2 | |
| s | 2 | |
| e | 2 | |
| r | 2 | |
| 0 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| u | 2 | |
| s | 2 | |
| e | 2 | |
| r | 2 | |
| 0 | 1 |
Unnamed: 21
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048572 |
|---|---|
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
Unnamed: 22
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | 75.0% |
| Missing | 1048571 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
| 0.0 | |
|---|---|
| 0.9 | |
| 0.31240577 |
Length
| Max length | 10 |
|---|---|
| Median length | 3 |
| Mean length | 4.75 |
| Min length | 3 |
Characters and Unicode
| Total characters | 19 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 50.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.9 |
| 4th row | 0.31240577 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 2 | < 0.1% |
| 0.9 | 1 | < 0.1% |
| 0.31240577 | 1 | < 0.1% |
| (Missing) | 1048571 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 2 | |
| 0.9 | 1 | |
| 0.31240577 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7 | |
| . | 4 | |
| 7 | 2 | 10.5% |
| 9 | 1 | 5.3% |
| 3 | 1 | 5.3% |
| 1 | 1 | 5.3% |
| 2 | 1 | 5.3% |
| 4 | 1 | 5.3% |
| 5 | 1 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 19 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7 | |
| . | 4 | |
| 7 | 2 | 10.5% |
| 9 | 1 | 5.3% |
| 3 | 1 | 5.3% |
| 1 | 1 | 5.3% |
| 2 | 1 | 5.3% |
| 4 | 1 | 5.3% |
| 5 | 1 | 5.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 19 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7 | |
| . | 4 | |
| 7 | 2 | 10.5% |
| 9 | 1 | 5.3% |
| 3 | 1 | 5.3% |
| 1 | 1 | 5.3% |
| 2 | 1 | 5.3% |
| 4 | 1 | 5.3% |
| 5 | 1 | 5.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 19 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7 | |
| . | 4 | |
| 7 | 2 | 10.5% |
| 9 | 1 | 5.3% |
| 3 | 1 | 5.3% |
| 1 | 1 | 5.3% |
| 2 | 1 | 5.3% |
| 4 | 1 | 5.3% |
| 5 | 1 | 5.3% |
Unnamed: 23
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048572 |
|---|---|
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
Unnamed: 24
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1048574 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
| 0.9 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0.9 |
|---|
Common Values
| Value | Count | Frequency (%) |
| 0.9 | 1 | < 0.1% |
| (Missing) | 1048574 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.9 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Unnamed: 25
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1048574 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0.0 |
|---|
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 1 | < 0.1% |
| (Missing) | 1048574 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Unnamed: 26
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 27
Text
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1048574 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | user |
|---|
| Value | Count | Frequency (%) |
| user | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 1 | |
| s | 1 | |
| e | 1 | |
| r | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| u | 1 | |
| s | 1 | |
| e | 1 | |
| r | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| u | 1 | |
| s | 1 | |
| e | 1 | |
| r | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| u | 1 | |
| s | 1 | |
| e | 1 | |
| r | 1 |
Unnamed: 28
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1048574 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
| 0.9 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0.9 |
|---|
Common Values
| Value | Count | Frequency (%) |
| 0.9 | 1 | < 0.1% |
| (Missing) | 1048574 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.9 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Unnamed: 29
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1048574 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0.0 |
|---|
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 1 | < 0.1% |
| (Missing) | 1048574 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Unnamed: 30
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 31
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 32
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 33
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 34
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 35
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 36
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 37
Text
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1048574 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 17 |
| Min length | 17 |
Characters and Unicode
| Total characters | 17 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Andhra Pradesh in |
|---|
| Value | Count | Frequency (%) |
| andhra | 1 | |
| pradesh | 1 | |
| in | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 2 | |
| d | 2 | |
| h | 2 | |
| r | 2 | |
| a | 2 | |
| 2 | ||
| A | 1 | |
| P | 1 | |
| e | 1 | |
| s | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 17 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 2 | |
| d | 2 | |
| h | 2 | |
| r | 2 | |
| a | 2 | |
| 2 | ||
| A | 1 | |
| P | 1 | |
| e | 1 | |
| s | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 17 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 2 | |
| d | 2 | |
| h | 2 | |
| r | 2 | |
| a | 2 | |
| 2 | ||
| A | 1 | |
| P | 1 | |
| e | 1 | |
| s | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 17 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 2 | |
| d | 2 | |
| h | 2 | |
| r | 2 | |
| a | 2 | |
| 2 | ||
| A | 1 | |
| P | 1 | |
| e | 1 | |
| s | 1 |
Unnamed: 38
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 39
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 40
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 41
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 42
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 43
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 44
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1048575 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 8.0 MiB |
Unnamed: 45
Text
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1048574 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | user |
|---|
| Value | Count | Frequency (%) |
| user | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 1 | |
| s | 1 | |
| e | 1 | |
| r | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| u | 1 | |
| s | 1 | |
| e | 1 | |
| r | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| u | 1 | |
| s | 1 | |
| e | 1 | |
| r | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| u | 1 | |
| s | 1 | |
| e | 1 | |
| r | 1 |
Unnamed: 46
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1048574 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
| 0.9 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0.9 |
|---|
Common Values
| Value | Count | Frequency (%) |
| 0.9 | 1 | < 0.1% |
| (Missing) | 1048574 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.9 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1 | |
| . | 1 | |
| 9 | 1 |
Unnamed: 47
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1048574 |
| Missing (%) | > 99.9% |
| Memory size | 8.0 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0.0 |
|---|
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 1 | < 0.1% |
| (Missing) | 1048574 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2 | |
| . | 1 |
| Number | Unnamed: 22 | |
|---|---|---|
| Number | 1.000 | 0.707 |
| Unnamed: 22 | 0.707 | 1.000 |
| Number | Carrier | Name | Gender | Address | JobTitle | CompanyName | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | Unnamed: 45 | Unnamed: 46 | Unnamed: 47 | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 9.170970e+11 | Aircel | Puneet Ji | NaN | Andhra Pradesh in | NaN | NaN | mobilearena@mail.com | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 9.170970e+11 | Aircel | NaN | NaN | Andhra Pradesh | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 9.170970e+11 | Aircel | Javed Cdm Mt | NaN | Andhra Pradesh | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 9.170970e+11 | Aircel | Sharada | NaN | Andhra Pradesh | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | 9.170970e+11 | Aircel | Ankit Singh | NaN | Andhra Pradesh in | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | 9.170970e+11 | Aircel | Lokesh M | NaN | Andhra Pradesh | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | 9.170970e+11 | Aircel | Arun Shonu | NaN | Andhra Pradesh in | NaN | NaN | arunshonu45@gmail.com | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | 9.170970e+11 | Aircel | My | NaN | Andhra Pradesh | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | 9.170970e+11 | Aircel | Chintu | NaN | Andhra Pradesh | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 9.170970e+11 | Aircel | Dilip | NaN | Andhra Pradesh | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| Number | Carrier | Name | Gender | Address | JobTitle | CompanyName | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | Unnamed: 45 | Unnamed: 46 | Unnamed: 47 | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1048565 | 9.180833e+11 | Aircel | Chote Boss | NaN | Bihar | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1048566 | 9.180833e+11 | Aircel | Indrajit Paper | NaN | Bihar | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1048567 | 9.180833e+11 | Aircel | Bicky Hp Pump | NaN | Bihar | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1048568 | 9.180833e+11 | Aircel | Rahul Singh Rajput | NaN | Bihar in | NaN | NaN | rahulsingh808330@gmail.com | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1048569 | 9.180833e+11 | Aircel | Niwesh Sir | NaN | Bihar | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1048570 | 9.180833e+11 | Aircel | Ravi Kumar | NaN | Bihar | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1048571 | 9.180833e+11 | Aircel | Dheeraj Kumar | NaN | Bihar in | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1048572 | 9.180833e+11 | Aircel | Penter Naya Chilwania | NaN | Bihar | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1048573 | 9.180833e+11 | Aircel | Satish | NaN | Bihar | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1048574 | 9.180833e+11 | Aircel | Tipu | NaN | Bihar | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |